/* Master Data INSERT script for table: User */

USE SGLDBMP01;
GO

/* SELECT * FROM dbo.[User];

*/

/* Data Types:
   
Column_name			Type			Length
-------------------------------------------
UserId				bigint			8
Name				varchar			100
EMail				nvarchar		180
DateCreated			datetime		8
CreatedBy			varchar			100
IsActive			char			1

*/

-- From SQL 2008 multiple row with single insert statement is possible
-- Ref: http://stackoverflow.com/questions/452859/inserting-multiple-rows-in-a-single-sql-query

INSERT INTO dbo.[User] (Name, EMail, CreatedBy, IsActive) VALUES 
	('SivaKumar Manoharan', 'gokul@statlight.in', 'SYSTEM', 'Y')
  , ('Mohanraj Ganapathi', 'gokul@statlight.in', 'SYSTEM', 'Y')
  , ('Ashok T', 'gokul@statlight.in', 'SYSTEM', 'Y')
  , ('Sofia Andrews', 'gokul@statlight.in', 'SYSTEM', 'Y')
  , ('Ishwarya Subbiah', 'gokul@statlight.in', 'SYSTEM', 'Y')
  , ('Manikandan', 'gokul@statlight.in', 'SYSTEM', 'Y')
  , ('MohanKumar', 'gokul@statlight.in', 'SYSTEM', 'Y');

/*OP: (7 row(s) affected)

*/